CREATE TABLE [dbo].[Mst_Products]
(
[ProductId] [bigint] NOT NULL IDENTITY(1, 1),
[CategoryId] [int] NOT NULL,
[ProductCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ProductName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ProductDesc] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PetaluId] [int] NULL,
[Quantity] [int] NOT NULL,
[GrossWeight] [decimal] (18, 3) NOT NULL,
[Wastage] [decimal] (18, 3) NOT NULL,
[NetWeight] [decimal] (18, 3) NOT NULL,
[Size] [decimal] (18, 2) NULL,
[SizeUnitId] [int] NULL,
[MakingCharge] [decimal] (18, 3) NOT NULL,
[OtherCharges] [decimal] (18, 3) NOT NULL,
[StonesDesc] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StonesCount] [int] NULL,
[StonesWeight] [decimal] (18, 3) NULL,
[StonesUnitId] [int] NULL,
[TotalStonesCost] [decimal] (18, 3) NULL,
[StatusId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Mst_Products] ADD CONSTRAINT [PK_Mst_Products] PRIMARY KEY CLUSTERED  ([ProductId]) ON [PRIMARY]
GO
